﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using Capstone_project.DatabaseAccessLayer;

namespace Capstone_project.BussnessLogicLayer
{
    class ProjectBUS
    {
        ConnectData connData = new ConnectData();
        public DataTable getList()
        {
            string sql = "SELECT ID_PROJECT, NAME_PROJECT, ID_CUSTOMER, ID_STATUS, START_DATE, END_DATE FROM PROJECT";
            return connData.getData(sql, true);
        }
        public string nextID()
        {
            string lastID = connData.getLastID("PROJECT", "ID_PROJECT");
            return Common.NextID(lastID, "");
        }
    }
}
